{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MASTER FILE","PENSION-STATE","PENSION-UGC","Psh"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MASTER FILE","index":0,"n_rows":9,"n_cols":56,"rows_kept":9,"cut":false,"hidden":true,"merged":[[3,52,4,52],[3,35,4,35],[3,39,4,39],[3,38,4,38],[3,45,4,45],[2,1,2,26],[3,26,4,26],[3,3,4,3],[2,27,2,53],[3,53,4,53],[3,50,4,50],[3,51,4,51],[3,44,4,44],[3,41,4,41],[3,42,4,42],[3,43,4,43],[3,33,4,33],[3,6,4,6],[3,7,4,7],[3,4,4,4],[3,5,4,5],[3,54,4,54],[3,37,4,37],[3,40,4,40],[3,19,3,22],[3,23,4,23],[3,24,4,24],[3,27,4,27],[3,36,4,36],[3,28,4,28],[3,29,4,29],[3,30,4,30],[3,25,4,25],[3,46,3,49],[3,32,4,32],[3,34,4,34],[3,31,4,31],[3,0,4,0],[3,18,4,18],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,15,4,15],[3,17,4,17],[3,1,4,1],[3,9,4,9],[3,16,4,16],[3,13,4,13],[3,2,4,2],[3,14,4,14],[3,8,4,8]]}
[]
[]
[null,"PENSION CALCULATION FOR THE GOVERNMENT EMPLOYEE RETIRED ON \"SUPERANNUATION\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENSION CALCULATION FOR \"VOLUNTARY RETIRED\" GOVERNMENT EMPLOYEE"]
["Basic Pay on Next year 1st March","Date of Birth","Date of Entry into Service","Month & Year of Retirement","Month & Year of Superannuation/ Retirement",{"$f":"IF(F6>=2,\"Years\",\"Year\")","v":"Years"},{"$f":"IF(G6>=2,\"Years\",\"Year\")","v":"Years"},"Net Qualify-ing Years",{"$f":"IF(I6>=2,\"Months\",\"Month\")","v":"Months"},{"$f":"IF(J6>=2,\"Months\",\"Month\")","v":"Months"},"No.of Qualifying service","No.of  Net Qualifying service (HYs)","No.of  Net Qualifying service (HYs)","Retirement GRATUITY Admisible","Retirement GRATUITY Admissible"," No.of Days EL at credit at the time of Retirement","EL ","Amount of EL Encashment","Total                                             [DCRG + Encashment]","PENSION",null,null,null,"Commutation of Pension","Commutation of Pension","Family Pension","Family Pension","Voluntary Retirement Date",{"$f":"IF(AC6>=2,\"Years\",\"Year\")","v":"Year"},{"$f":"IF(AD6>=2,\"Years\",\"Year\")","v":"Year"},"Net Qualify-ing Years",{"$f":"IF(AF6>=2,\"Months\",\"Month\")","v":"Month"},{"$f":"IF(AG6>=2,\"Months\",\"Month\")","v":"Month"},"No.of Qualifying service","No.of  Net Qualifying service (HYs)","No.of  Net Qualifying service (HYs)","Maximum Weitage of 5 years added in respect of Voluntary Retirement","Gross Qualifying Service","Net Qualifying Service","Net Qualifying Service","Retirement GRATUITY Admisible","Retirement GRATUITY Admissible"," No.of Days EL at credit at the time of Retirement","EL ","Amount of EL Encashment","Total [DCRG + Encashment]","PENSION",null,null,null,"Commutation of Pension","Commutation of Pension","Family Pension","Family Pension","Commutation Table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASIC","BASIC","DA                                         @                                      25.25%","TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASIC","BASIC","DA                                         @                                      25.25%","TOTAL"]
[{"$f":"'PENSION-STATE'!$H$2","v":0},{"$f":"'PENSION-STATE'!$H$3","v":"00:00:00"},{"$f":"'PENSION-STATE'!$H$4","v":"00:00:00"},{"$f":"DATEVALUE(\"1-1-60\")+B6-2","v":"1959-12-30"},{"$f":"IF(B6=\"\",\"\",D6)","v":"1959-12-30"},{"$f":"DATEDIF(C6,D6,\"Y\")","v":59},{"$f":"IF(F6>33,33,F6)","v":33},{"$f":"IF(C6=\"\",\"\",G6)","v":33},{"$f":"DATEDIF(C6,D6,\"Ym\")","v":11},{"$f":"IF(C6=\"\",\"\",I6)","v":11},{"$f":"F6&\" \"&$G$4&\",\"&\" \"&J6&\" \"&$J$4","v":"59 Years, 11 Months"},{"$f":"IF(C6=\"\",\"\",IF(J6<=3,0,IF(J6<9,1,IF(J6<=12,2)))+H6*2)","v":68},{"$f":"IF(L6>66,66,L6)","v":66},{"$f":"IF(L6=\"\",\"0\",M6*A6/4)","v":0},{"$f":"IF(N6=\"0\",0,IF(N6>2000000,2000000,N6))","v":0},300,{"$f":"TRUNC(A6*Psh!$F$9+0.5)+A6","v":0},{"$f":"(Q6*P6)/30","v":0},{"$f":"O6+R6","v":0},{"$f":"(A6*M6)/132","v":0},{"$f":"IF(L6=\"\",\"0\",IF(T6<8500,8500,IF(T6>75300,75300,T6)))","v":8500},{"$f":"TRUNC(U6*Psh!$F$9+0.5)","v":2975},{"$f":"SUM(U6:V6)","v":11475},{"$f":"(TRUNC(U6/3+0.5)*12)","v":33996},{"$f":"TRUNC(X6*9.81+0.5)","v":333501},{"$f":"TRUNC(A6*30%+0.5)","v":0},{"$f":"IF(L6=\"\",\"0\",IF(Z6<4800,4800,IF(Z6>23940,23940,Z6)))","v":4800},{"$f":"'PENSION-STATE'!$H$5","v":"00:00:00"},{"$f":"DATEDIF(C6,AB6,\"Y\")","v":0},{"$f":"IF(AC6>33,33,AC6)","v":0},{"$f":"IF(C6=\"\",\"\",AD6)","v":0},{"$f":"DATEDIF(C6,AB6,\"Ym\")","v":0},{"$f":"IF(C6=\"\",\"\",AF6)","v":0},{"$f":"AC6&\" \"&$G$4&\",\"&\" \"&AG6&\" \"&$J$4","v":"0 Years, 0 Months"},{"$f":"IF(C6=\"\",\"\",IF(AG6<=3,0,IF(AG6<9,1,IF(AG6<=12,2)))+AE6*2)","v":0},{"$f":"IF(AI6>66,66,AI6)","v":0},{"$f":"'PENSION-STATE'!$H$6","v":0},{"$f":"(AK6*2)+AJ6","v":0},{"$f":"IF(AL6>66,66,AL6)","v":0},{"$f":"IF(AL6>60,60,AL6)","v":0},{"$f":"IF(AM6=\"\",\"0\",AM6*A6/4)","v":0},{"$f":"IF(AB6=\"\",0,IF(AO6>2000000,2000000,AO6))","v":0},{"$f":"'PENSION-STATE'!$H$7","v":0},{"$f":"TRUNC(A6*Psh!$F$9+0.5)+A6","v":0},{"$f":"(AR6*AQ6)/30","v":0},{"$f":"AP6+AS6","v":0},{"$f":"TRUNC(A6*AN6)/120","v":0},{"$f":"IF(AB6=\"\",\"0\",IF(AU6<8500,8500,IF(AU6>75300,75300,AU6)))","v":8500},{"$f":"TRUNC(AV6*Psh!$F$9+0.5)","v":2975},{"$f":"SUM(AV6:AW6)","v":11475},{"$f":"(TRUNC(AV6/3+0.5)*12)","v":33996},{"$f":"TRUNC(AY6*BC6+0.5)","v":{"$error":"#N/A"}},{"$f":"TRUNC(A6*30%+0.5)","v":0},{"$f":"IF(AB6=\"\",\"0\",IF(BA6<8500,8500,IF(BA6>45180,45180,BA6)))","v":8500},{"$f":"VLOOKUP(BD6,Psh!$U$25:$V$92,2)","v":{"$error":"#N/A"}},{"$f":"DATEDIF(B6,AB6,\"Y\")","v":0}]
[]
[]
[{"$f":"'PENSION-UGC'!$H$2","v":0},{"$f":"'PENSION-UGC'!$H$3","v":"00:00:00"},{"$f":"'PENSION-UGC'!$H$4","v":"00:00:00"},{"$f":"DATEVALUE(\"1-1-60\")+B9-2","v":"1959-12-30"},{"$f":"IF(B9=\"\",\"\",D9)","v":"1959-12-30"},{"$f":"DATEDIF(C9,D9,\"Y\")","v":59},{"$f":"IF(F9>33,33,F9)","v":33},{"$f":"IF(C9=\"\",\"\",G9)","v":33},{"$f":"DATEDIF(C9,D9,\"Ym\")","v":11},{"$f":"IF(C9=\"\",\"\",I9)","v":11},{"$f":"F9&\" \"&$G$4&\",\"&\" \"&J9&\" \"&$J$4","v":"59 Years, 11 Months"},{"$f":"IF(C9=\"\",\"\",IF(J9<=3,0,IF(J9<9,1,IF(J9<=12,2)))+H9*2)","v":68},{"$f":"IF(L9>66,66,L9)","v":66},{"$f":"IF(L9=\"\",\"0\",M9*A9/4)","v":0},{"$f":"IF(N9=\"0\",0,IF(N9>2000000,2000000,N9))","v":0},300,{"$f":"TRUNC(A9*Psh!$F$9+0.5)+A9","v":0},{"$f":"(Q9*P9)/30","v":0},{"$f":"O9+R9","v":0},{"$f":"(A9*M9)/132","v":0},{"$f":"IF(L9=\"\",\"0\",IF(T9<8500,8500,IF(T9>75300,75300,T9)))","v":8500},{"$f":"TRUNC(U9*Psh!$F$9+0.5)","v":2975},{"$f":"SUM(U9:V9)","v":11475},{"$f":"(TRUNC(U9/3+0.5)*12)","v":33996},{"$f":"TRUNC(X9*9.81+0.5)","v":333501},{"$f":"TRUNC(A9*30%+0.5)","v":0},{"$f":"IF(L9=\"\",\"0\",IF(Z9<4800,4800,IF(Z9>23940,23940,Z9)))","v":4800},{"$f":"'PENSION-UGC'!$H$5","v":"00:00:00"},{"$f":"DATEDIF(C9,AB9,\"Y\")","v":0},{"$f":"IF(AC9>33,33,AC9)","v":0},{"$f":"IF(C9=\"\",\"\",AD9)","v":0},{"$f":"DATEDIF(C9,AB9,\"Ym\")","v":0},{"$f":"IF(C9=\"\",\"\",AF9)","v":0},{"$f":"AC9&\" \"&$G$4&\",\"&\" \"&AG9&\" \"&$J$4","v":"0 Years, 0 Months"},{"$f":"IF(C9=\"\",\"\",IF(AG9<=3,0,IF(AG9<9,1,IF(AG9<=12,2)))+AE9*2)","v":0},{"$f":"IF(AI9>66,66,AI9)","v":0},".",".",{"$f":"IF(AL9>66,66,AL9)","v":66},{"$f":"IF(AL9>60,60,AL9)","v":60},{"$f":"IF(AM9=\"\",\"0\",AM9*A9/4)","v":0},{"$f":"IF(AB9=\"\",0,IF(AO9>2000000,2000000,AO9))","v":0},{"$f":"'PENSION-UGC'!$H$7","v":0},{"$f":"TRUNC(A9*Psh!$F$9+0.5)+A9","v":0},{"$f":"(AR9*AQ9)/30","v":0},{"$f":"AP9+AS9","v":0},{"$f":"TRUNC(A9*AN9)*1.04/120","v":0},{"$f":"IF(AB9=\"\",\"0\",IF(AU9<8500,8500,IF(AU9>75300,75300,AU9)))","v":8500},{"$f":"TRUNC(AV9*Psh!$F$9+0.5)","v":2975},{"$f":"SUM(AV9:AW9)","v":11475},{"$f":"(TRUNC(AV9/3+0.5)*12)","v":33996},{"$f":"TRUNC(AY9*BC9+0.5)","v":{"$error":"#N/A"}},{"$f":"TRUNC(A9*30%+0.5)*1.04","v":0},{"$f":"IF(AB9=\"\",\"0\",IF(BA9<8500,8500,IF(BA9>45180,45180,BA9)))","v":8500},{"$f":"VLOOKUP(BD9,Psh!$U$25:$V$92,2)","v":{"$error":"#N/A"}},{"$f":"DATEDIF(B9,AB9,\"Y\")","v":0}]

{"sheet":"PENSION-STATE","index":1,"n_rows":103,"n_cols":12,"rows_kept":103,"cut":false,"hidden":false,"merged":[[42,2,42,3],[34,1,34,4],[34,5,34,9],[35,1,35,4],[35,5,35,9],[36,1,36,4],[36,5,36,9],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[32,1,32,9],[27,7,27,9],[0,7,0,9],[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[0,1,0,6],[85,1,85,4],[85,5,85,9],[79,1,79,9],[81,1,81,9],[69,1,69,5],[69,6,69,9],[70,1,70,5],[71,1,71,9],[75,1,77,2],[75,3,75,9],[63,1,63,9],[65,1,65,9],[67,1,67,5],[67,6,67,9],[68,1,68,5],[68,6,68,9],[56,1,57,3],[56,7,57,7],[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,4,6],[5,1,5,6],[21,1,21,6],[13,7,13,9],[6,1,6,6],[6,7,6,9],[19,1,19,6],[14,1,14,6],[14,7,14,9],[19,7,19,9],[15,1,15,6],[15,7,15,9],[17,1,17,6],[17,7,17,9],[18,1,18,6],[18,7,18,9],[16,1,16,6],[16,7,16,9],[7,1,7,6],[7,7,7,9],[11,1,11,9],[56,8,57,8],[57,4,57,6],[59,1,59,9],[49,1,49,4],[49,5,49,9],[53,1,54,3],[53,4,53,7],[54,4,54,7],[5,7,5,9],[12,1,12,5],[12,6,12,9],[21,7,21,9],[44,1,45,1],[44,3,45,3],[44,5,45,5],[44,6,45,6],[47,1,47,9],[37,1,37,4],[37,5,37,9],[39,1,39,9],[41,1,42,1],[41,2,41,3],[41,4,42,4],[41,5,41,7],[10,1,10,9],[28,7,28,9],[29,7,29,9],[30,7,30,9],[26,1,26,2],[20,1,20,2],[22,7,22,9],[23,7,23,9],[25,7,25,9],[22,1,22,6],[23,1,23,6],[25,1,25,6],[24,1,24,6],[24,7,24,9],[98,3,98,6],[99,3,99,6],[100,3,100,6],[101,3,101,6],[102,3,102,6],[70,6,70,9],[93,2,93,8],[96,3,96,7],[95,8,96,8],[95,9,96,9],[95,1,96,2],[87,2,87,8],[91,1,91,2],[83,1,83,2],[89,1,89,4]]}
[1,"NAME",null,null,null,null,null,0]
[2,"BASIC PAY",null,null,null,null,null,0]
[3,"DATE OF BIRTH",null,null,null,null,null,"00:00:00"]
[4,"DATE OF ENTRY INTO SERVICE",null,null,null,null,null,"00:00:00"]
[5,"DATE OF RETIREMENT [SUPERANNUATION/VRS]",null,null,null,null,null,"00:00:00"]
[6,"Maximum weitage of 5 years in respect of VRS",null,null,null,null,null,0]
[7,"No. of Earned Leave at credit",null,null,null,null,null,0]
[8,"DA",null,null,null,null,null,0.35]
[]
[]
[null,"PENSION CALCULATION SHEET FOR STATE SCALE"]
[null,"PENSION, GRATUITY, COMMUTTATION OF PENSION, EL ENCASHMENT AND FAMILY PENSION"]
[null,"CALCULATION SHEET IN RESPECT OF Sri./Smt.",null,null,null,null,{"$f":"$H$1","v":0}]
[1,"QUALIFYING SERVICE:",null,null,null,null,null,"DD-MM-YYYY",null,null,null," "]
[null,"[a] Date of Birth",null,null,null,null,null,{"$f":"'MASTER FILE'!$B$6","v":"00:00:00"},null,null,null," "]
[null,"[b] Deduct date of entry into service",null,null,null,null,null,{"$f":"'MASTER FILE'!$C$6","v":"00:00:00"},null,null," "," "]
[null,"[c] Date of Retirement/Superannuation/VRS",null,null,null,null,null,{"$f":"'MASTER FILE'!$AB$6","v":"00:00:00"},null,null," "," "]
[null,"[d] Gross Qualifying Service",null,null,null,null,null,{"$f":"'MASTER FILE'!$AH$6","v":"0 Years, 0 Months"},null,null," "," "]
[null,"[e] Net Qualifying Service [HYS]",null,null,null,null,null,{"$f":"'MASTER FILE'!$AJ$6","v":0},null,null," "]
[null,"[f] Age at the time of Retirement",null,null,null,null,null,{"$f":"'MASTER FILE'!$BD$6","v":0}]
[null,"SPECIAL ADDITIONS:"]
[null,"[a] Special additions in respect of Govt. Servants who have been appointed under Speical Recruitment Rules (Rule 247)",null,null,null,null,null,0]
[null,"[b] Maximum weightage of 5 years are to be added in respect of  Voluntary retirement cases, [Rule 285 (I) (a)]",null,null,null,null,null,{"$f":"'MASTER FILE'!$AK$6","v":0}]
[null,"[c] Military service upto 5 years to be added vide Rule 219b",null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"'MASTER FILE'!$AN$6+(H22+H24)*2","v":0}]
[null,"GROSS QUALIFYING SERVICE",null,null,null,null,null,{"$f":"IF(H25>66,66,H25)","v":0}]
[null,"DEDUCTIONS:"]
[null,"[1] Minor Service (Rule 220)",null,null,null,null,null,0]
[null,"[2] LWA/EOL in excess of 3 years (Rule 244A)",null,null,null,null,null,0]
[null,"[3] Suspension confirmed period (Rule 250)",null,null,null,null,null,0]
[null,"NET QUALIFYING SERVICE:",null,null,null,null,null,{"$f":"H26-(H28+H29+H30)","v":0}]
[]
["NOTE","The Maximum Pension/Gratuity is earned after 33 years Qualifying Service and any service beyond this Maximum limits is ignored in calculating the length of service.  Qualifying Service should be expressed terms of completed six monthly periods.  For this purpose fraction of a year in the Qualifying Service should be recknoed as follows:"]
[]
[null,"FRACTION OF A YEAR",null,null,null,"NO.OF COMPLETED SIX MONTHLY PERIODS [Half Year]"]
[null,"Less than 3 Months",null,null,null,"Nil"]
[null,"3 Months and above but less than 9 Months",null,null,null,"One"]
[null,"9 Months and above",null,null,null,"Two"]
[]
[2,"PENSION FORMULA (Rule 291, 292 of KCSR) and G.O. No.FD-38-SRS-84 dated:31-08-1994."]
[]
[null,"PENSION","LAST EMOLUMENTS",null,"X","NET Q.S. (In terms of H.Y.S.)"]
[null,null,2,null,null,null,60]
[]
[null,"PENSION",{"$f":"'MASTER FILE'!$A$6","v":0},"X",{"$f":"$H$31","v":0},"=",{"$f":"'MASTER FILE'!$AV$6","v":8500},"BASIC","DA","TOTAL"]
[null,null,2,null,60,null,null,{"$f":"G45","v":8500},{"$f":"'MASTER FILE'!$AW$6","v":2975},{"$f":"SUM(H46:I46)","v":11475}]
[]
["NOTE","The term emoluments includes Basic Pay, Special Pay, Interim Relief, Personal Pay (Rule 8(35), Stagnation Increment, Additional Increment Pension should be always expressed in whole Rupees fraction of a Rupees should be rounded off to next Rupee."]
[]
[null,"Minimum Pension Rs.8500/- p.m.",null,null,null,"Maximum Pension is Rs.75300/- p.m."]
[]
[3,"RETIREMENT GRATUITY:"]
[]
[null,"RETIREMENT GRATUITY  =",null,null,"Last Emoluments X Net Q.S. (H.Y.S.)"]
[null,null,null,null,4]
[]
[null,"RETIREMENT GRATUITY  =",null,null,{"$f":"C45","v":0},"X",{"$f":"'MASTER FILE'!$AM$6","v":0},"=",{"$f":"'MASTER FILE'!$AP$6","v":0}]
[null,null,null,null,4]
[]
[null,"[Maximum amount of Gratuity is Rs.20.00 lakhs]"]
[]
[4,"DEATH GRATUITY:"]
[]
[null,"In the event of Death of a Government Servant in service irrespective of whether he was permanent or temporary, Death Gratuity is admissible at the following rates:"]
[]
[null,"LENTH OF SERVICE"]
[]
[null,"   [i] Less than one year ",null,null,null,null," 2 Times of Emoluments"]
[null,"  [ii] One year or more but less than 5 years",null,null,null,null," 6 Times of Emoluments"]
[null," [iii] 5 years or more but less than 20 years",null,null,null,null,"12 Times of Emoluments"]
[null,"  [iv] 20 years or more",null,null,null,null,"Half of Emoluments for every completed 6 monthly period of Q.S. subject to a maximum of 33 times emoluments or Rs.10.00 lakhs whichever is less."]
[null,"The Death Gratuity is payable even to the family of a Government Servant who commits suicide."]
[]
[5,"COMMUTATION OF PENSION"]
[]
[null,"Commutation Value of Pension",null,"Pension / 3   X  Commutaion Factor  X  12"]
[]
[null,null,null,{"$f":"G45/3","v":2833.3333333333335},"X",{"$f":"'MASTER FILE'!$BC$6","v":{"$error":"#N/A"}},"X",12,"=",{"$f":"'MASTER FILE'!$AZ$6","v":{"$error":"#N/A"}}]
[]
["NOTE","Lump sum payable is related to Government Servants age.  In the Table given under Rule 380, Commutation factor is given as number of years of purchase.  The maximum amount that can be commuted is one-third of original pension.  The amount to be commuted is to be multiplied by the number of years of purchase or Government Servants age on the next date of birth."]
[]
["EX","If a Government Servant retired on completion of 56 years age if he apply for commutation of Rs.2500/-  out of his total pension is Rs.7500/- within a year, commutation amount will be Rs.2500 x 12 x 11.10 = 333000."]
[]
[6,"FAMILY PENSION:"]
[]
[null,"Minimum Pension Rs.8500/- p.m.",null,null,null,"Maximum Pension is Rs.45180/- p.m."]
[]
[null,null,"FAMILY PENSION = Basic Pay X 30%"]
[]
[null,"FAMILY PENSION =",null,null,null,{"$f":"C45","v":0},"X",0.3,"=",{"$f":"'MASTER FILE'!$BB$6","v":8500}]
[]
[7,"EL ENCASHMENT"]
[]
[null,null,"BASIC PAY + DA X No.of EL / 30"]
[]
[null,"EL ENCASHMENT =",null,{"$f":"C45","v":0},"+",{"$f":"TRUNC(D96*Psh!$F$9+0.5)","v":0},"X",{"$f":"'MASTER FILE'!$AQ$6","v":0},"=",{"$f":"'MASTER FILE'!$AS$6","v":0}]
[null,null,null,30]
[]
[null,null,1,"PENSION",null,null,null,{"$f":"J46","v":11475}]
[null,null,2,"RETIREMENT GRATUITY",null,null,null,null,{"$f":"I57","v":0}]
[null,null,3,"COMMUTATION OF PENSION",null,null,null,null,{"$f":"J78","v":{"$error":"#N/A"}}]
[null,null,4,"EL ENCASHMENT",null,null,null,null,{"$f":"J96","v":0}]
[null,null,null,"TOTAL [2+3+4]",null,null,null,null,{"$f":"SUM(I100:I102)","v":{"$error":"#N/A"}}]

{"sheet":"PENSION-UGC","index":2,"n_rows":103,"n_cols":12,"rows_kept":103,"cut":false,"hidden":false,"merged":[[98,3,98,6],[99,3,99,6],[100,3,100,6],[101,3,101,6],[102,3,102,6],[24,1,24,6],[91,1,91,2],[93,2,93,8],[95,1,96,2],[95,8,96,8],[59,1,59,9],[63,1,63,9],[65,1,65,9],[67,1,67,5],[67,6,67,9],[68,1,68,5],[68,6,68,9],[53,1,54,3],[53,4,53,7],[54,4,54,7],[56,1,57,3],[56,7,57,7],[56,8,57,8],[95,9,96,9],[96,3,96,7],[79,1,79,9],[81,1,81,9],[83,1,83,2],[85,1,85,4],[85,5,85,9],[87,2,87,8],[69,1,69,5],[69,6,69,9],[70,1,70,5],[70,6,70,9],[71,1,71,9],[75,1,77,2],[75,3,75,9],[89,1,89,2],[57,4,57,6],[44,1,45,1],[44,3,45,3],[44,5,45,5],[44,6,45,6],[47,1,47,9],[49,1,49,4],[49,5,49,9],[37,1,37,4],[37,5,37,9],[39,1,39,9],[41,1,42,1],[41,2,41,3],[41,4,42,4],[41,5,41,7],[42,2,42,3],[41,8,42,8],[41,9,42,9],[32,1,32,9],[34,1,34,4],[34,5,34,9],[35,1,35,4],[35,5,35,9],[36,1,36,4],[36,5,36,9],[28,1,28,6],[28,7,28,9],[29,1,29,6],[29,7,29,9],[30,1,30,6],[30,7,30,9],[23,1,23,6],[23,7,23,9],[25,1,25,6],[25,7,25,9],[26,1,26,2],[27,1,27,6],[27,7,27,9],[24,7,24,9],[19,1,19,6],[19,7,19,9],[20,1,20,2],[21,1,21,6],[21,7,21,9],[22,1,22,6],[22,7,22,9],[17,1,17,6],[17,7,17,9],[18,1,18,6],[18,7,18,9],[12,1,12,5],[12,6,12,9],[13,7,13,9],[14,1,14,6],[14,7,14,9],[15,1,15,6],[15,7,15,9],[10,1,10,9],[11,1,11,9],[3,1,3,6],[3,7,3,9],[4,1,4,6],[4,7,4,9],[5,1,5,6],[5,7,5,9],[16,1,16,6],[16,7,16,9],[0,1,0,6],[0,7,0,9],[1,1,1,6],[1,7,1,9],[2,1,2,6],[2,7,2,9],[6,1,6,6],[6,7,6,9],[7,1,7,6],[7,7,7,9]]}
[1,"NAME",null,null,null,null,null,0]
[2,"BASIC PAY",null,null,null,null,null,0]
[3,"DATE OF BIRTH",null,null,null,null,null,"00:00:00"]
[4,"DATE OF ENTRY INTO SERVICE",null,null,null,null,null,"00:00:00"]
[5,"DATE OF RETIREMENT [SUPERANNUATION/VRS]",null,null,null,null,null,"00:00:00"]
[6,"Maximum weitage of 5 years in respect of VRS",null,null,null,null,null,0]
[7,"No. of Earned Leave at credit",null,null,null,null,null,0]
[8,"DA",null,null,null,null,null,0.42]
[]
[]
[null,"PENSION CALCULATION SHEET FOR UGC SCALE"]
[null,"PENSION, GRATUITY, COMMUTTATION OF PENSION, EL ENCASHMENT AND FAMILY PENSION"]
[null,"CALCULATION SHEET IN RESPECT OF Sri./Smt.",null,null,null,null,{"$f":"$H$1","v":0}]
[1,"QUALIFYING SERVICE:",null,null,null,null,null,"DD-MM-YYYY",null,null,null," "]
[null,"[a] Date of Birth",null,null,null,null,null,{"$f":"'MASTER FILE'!$B$9","v":"00:00:00"},null,null,null," "]
[null,"[b] Deduct date of entry into service",null,null,null,null,null,"1982-07-01",null,null," "," "]
[null,"[c] Date of Retirement/Superannuation/VRS",null,null,null,null,null,{"$f":"'MASTER FILE'!$AB$9","v":"00:00:00"},null,null," "," "]
[null,"[d] Gross Qualifying Service",null,null,null,null,null,{"$f":"'MASTER FILE'!$AH$9","v":"0 Years, 0 Months"},null,null," "," "]
[null,"[e] Net Qualifying Service [HYS]",null,null,null,null,null,{"$f":"'MASTER FILE'!$AJ$9","v":0},null,null," "]
[null,"[f] Age at the time of Retirement",null,null,null,null,null,{"$f":"'MASTER FILE'!$BD$9","v":0}]
[null,"SPECIAL ADDITIONS:"]
[null,"[a] Special additions in respect of Govt. Servants who have been appointed under Speical Recruitment Rules (Rule 247)",null,null,null,null,null,0]
[null,"[b] Maximum weightage of 5 years are to be added in respect of  Voluntary retirement cases, [Rule 285 (I) (a)]",null,null,null,null,null,{"$f":"'MASTER FILE'!$AK$9","v":"."}]
[null,"[c] Military service upto 5 years to be added vide Rule 219b",null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"'MASTER FILE'!$AN$9+(H22+H24)*2","v":60}]
[null,"GROSS QUALIFYING SERVICE",null,null,null,null,null,{"$f":"IF(H25>66,66,H25)","v":60}]
[null,"DEDUCTIONS:"]
[null,"[1] Minor Service (Rule 220)",null,null,null,null,null,0]
[null,"[2] LWA/EOL in excess of 3 years (Rule 244A)",null,null,null,null,null,0]
[null,"[3] Suspension confirmed period (Rule 250)",null,null,null,null,null,0]
[null,"NET QUALIFYING SERVICE:",null,null,null,null,null,{"$f":"H26-(H28+H29+H30)","v":60}]
[]
["NOTE","The Maximum Pension/Gratuity is earned after 33 years Qualifying Service and any service beyond this Maximum limits is ignored in calculating the length of service.  Qualifying Service should be expressed terms of completed six monthly periods.  For this purpose fraction of a year in the Qualifying Service should be recknoed as follows:"]
[]
[null,"FRACTION OF A YEAR",null,null,null,"NO.OF COMPLETED SIX MONTHLY PERIODS [Half Year]",null,null,null,null,null,{"$f":"72330*33*1.839/66","v":66507.434999999998}]
[null,"Less than 3 Months",null,null,null,"Nil"]
[null,"3 Months and above but less than 9 Months",null,null,null,"One"]
[null,"9 Months and above",null,null,null,"Two"]
[]
[2,"PENSION FORMULA (Rule 291, 292 of KCSR) and G.O. No.FD-38-SRS-84 dated:31-08-1994."]
[]
[null,"PENSION","LAST EMOLUMENTS",null,"X","NET Q.S. (In terms of H.Y.S.)",null,null,"X",1.04]
[null,null,2,null,null,null,66]
[]
[null,"PENSION",{"$f":"'MASTER FILE'!$A$9","v":0},"X",{"$f":"$H$31","v":60},"x 1.04=",{"$f":"'MASTER FILE'!$AV$9","v":8500},"BASIC","DA","TOTAL"]
[null,null,2,null,60,null,null,{"$f":"G45","v":8500},{"$f":"'MASTER FILE'!$AW$9","v":2975},{"$f":"SUM(H46:I46)","v":11475}]
[]
["NOTE","The term emoluments includes Basic Pay, Special Pay, Interim Relief, Personal Pay (Rule 8(35), Stagnation Increment, Additional Increment Pension should be always expressed in whole Rupees fraction of a Rupees should be rounded off to next Rupee."]
[]
[null,"Minimum Pension Rs.8500/- p.m.",null,null,null,"Maximum Pension is Rs.75300/- p.m."]
[]
[3,"RETIREMENT GRATUITY:"]
[]
[null,"RETIREMENT GRATUITY  =",null,null,"Last Emoluments X Net Q.S. (H.Y.S.)"]
[null,null,null,null,4]
[]
[null,"RETIREMENT GRATUITY  =",null,null,{"$f":"C45","v":0},"X",{"$f":"'MASTER FILE'!$AM$9","v":66},"=",{"$f":"'MASTER FILE'!$AP$9","v":0}]
[null,null,null,null,4]
[]
[null,"[Maximum amount of Gratuity is Rs.20.00 lakhs]"]
[]
[4,"DEATH GRATUITY:"]
[]
[null,"In the event of Death of a Government Servant in service irrespective of whether he was permanent or temporary, Death Gratuity is admissible at the following rates:"]
[]
[null,"LENTH OF SERVICE"]
[]
[null,"   [i] Less than one year ",null,null,null,null," 2 Times of Emoluments"]
[null,"  [ii] One year or more but less than 5 years",null,null,null,null," 6 Times of Emoluments"]
[null," [iii] 5 years or more but less than 20 years",null,null,null,null,"12 Times of Emoluments"]
[null,"  [iv] 20 years or more",null,null,null,null,"Half of Emoluments for every completed 6 monthly period of Q.S. subject to a maximum of 33 times emoluments or Rs.10.00 lakhs whichever is less."]
[null,"The Death Gratuity is payable even to the family of a Government Servant who commits suicide."]
[]
[5,"COMMUTATION OF PENSION"]
[]
[null,"Commutation               Value of Pension",null,"Pension / 3   X  Commutaion Factor  X  12"]
[]
[null,null,null,{"$f":"G45/3","v":2833.3333333333335},"X",{"$f":"'MASTER FILE'!$BC$9","v":{"$error":"#N/A"}},"X",12,"=",{"$f":"'MASTER FILE'!$AZ$9","v":{"$error":"#N/A"}}]
[]
["NOTE","Lump sum payable is related to Government Servants age.  In the Table given under Rule 380, Commutation factor is given as number of years of purchase.  The maximum amount that can be commuted is one-third of original pension.  The amount to be commuted is to be multiplied by the number of years of purchase or Government Servants age on the next date of birth."]
[]
["EX","If a Government Servant retired on completion of 56 years age if he apply for commutation of Rs.2500/-  out of his total pension is Rs.7500/- within a year, commutation amount will be Rs.2500 x 12 x 11.10 = 333000."]
[]
[6,"FAMILY PENSION:"]
[]
[null,"Minimum Pension Rs.8500/- p.m.",null,null,null,"Maximum Pension is Rs.45180/- p.m."]
[]
[null,null,"FAMILY PENSION = Basic Pay  X  30% X 1.04"]
[]
[null,"FAMILY PENSION =",null,{"$f":"C45","v":0},"X",0.3,"X",1.04,"=",{"$f":"'MASTER FILE'!$BB$9","v":8500}]
[]
[7,"EL ENCASHMENT"]
[]
[null,null,"BASIC PAY + DA X No.of EL / 30"]
[]
[null,"EL ENCASHMENT =",null,{"$f":"C45","v":0},"+",{"$f":"TRUNC(D96*H8+0.5)","v":0},"X",{"$f":"'MASTER FILE'!$AQ$9","v":0},"=",{"$f":"'MASTER FILE'!$AS$9","v":0}]
[null,null,null,30]
[]
[null,null,1,"PENSION",null,null,null,{"$f":"J46","v":11475}]
[null,null,2,"RETIREMENT GRATUITY",null,null,null,null,{"$f":"I57","v":0}]
[null,null,3,"COMMUTATION OF PENSION",null,null,null,null,{"$f":"J78","v":{"$error":"#N/A"}}]
[null,null,4,"EL ENCASHMENT",null,null,null,null,{"$f":"J96","v":0}]
[null,null,null,"TOTAL [2+3+4]",null,null,null,null,{"$f":"SUM(I100:I102)","v":{"$error":"#N/A"}}]

{"sheet":"Psh","index":3,"n_rows":107,"n_cols":24,"rows_kept":107,"cut":false,"hidden":true,"merged":[[167,7,167,8],[156,7,156,8],[27,7,27,8],[2,13,2,14],[0,13,0,14],[1,13,1,14],[0,3,0,4],[0,0,0,1],[7,0,7,1]]}
["HRA",null,null,"INCREMENT",null,"CITY",null,null,null,null,null,null,null,"Budget estimate for the year 2008-09",null,null,null,"PAY-SCALE",null,null,"-",0,0,0]
["A",0.3,null,"2016-03-01",12,"A",null,null,null,null,null,null,null,"Non-teaching Staff NON-PLAN",null,null,null,"-",null,null,"Attender","10400-16400",300,0]
["B",0.2,null,"2016-04-01",11,"B",null,null,null,null,null,null,null,"Designation-wise Total",null,null,1,"9600-14550",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"9600-14550\")","v":{"$error":"#REF!"}},null,"Daffedar","10400-16400",300,0]
["B1",0.1,null,"2016-05-01",10,"B1",null,null,null,null,null,null,null,null,null,null,2,"10400-16400",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"10400-16400\")","v":{"$error":"#REF!"}},null,"Driver","11600-21000",300,135]
["C",0.1,null,"2016-06-01",9,"C",null,null,null,null,null,null,1,"Superintendent",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Suptd.\")","v":{"$error":"#REF!"}},null,3,"11000-19000",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"11000-19000\")","v":{"$error":"#REF!"}},null,"FDA","14550-26700",0,0]
[null,null,null,"2016-07-01",8,null,null,null,null,null,null,null,2,"FDA",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"FDA\")","v":{"$error":"#REF!"}},null,4,"11600-21000",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"11600-21000\")","v":{"$error":"#REF!"}},null,"FDA (A/cs)","14550-26700",0,0]
[null,null,null,"2016-08-01",7,null,null,null,null,null,null,null,3,"SDA",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"SDA\")","v":{"$error":"#REF!"}},null,5,"12500-24000",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"12500-24000\")","v":{"$error":"#REF!"}},null,"Lab.Asst.","10400-16400",0,0]
["CCA",null,null,"2016-09-01",6,"DA",null,"PH","M",null,null,null,4,"Sr.Typist",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Sr.Typist\")","v":{"$error":"#REF!"}},null,6,"13600-26000",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"13600-26000\")","v":{"$error":"#REF!"}},null,"Lib.Asst.","10400-16400",0,0]
["A",350,null,"2016-10-01",5,{"$f":"'PENSION-STATE'!$H$8","v":0.35},null,"-","F",null,null,null,5,"Typist",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Typist\")","v":{"$error":"#REF!"}},null,7,"14550-26700",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"14550-26700\")","v":{"$error":"#REF!"}},null,"Mechanic","11600-21000",0,0]
["B",250,null,"2016-11-01",4,null,null,null,"-",null,null,null,6,"Stenographer",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Stenographer\")","v":{"$error":"#REF!"}},null,8,"16000-29600",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"16000-29600\")","v":{"$error":"#REF!"}},null,"N.Watchman","9600-14550",300,0]
["C",0,null,"2016-12-01",3,null,null,null,null,null,null,null,7,"Sr.Driver",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Sr.Driver\")","v":{"$error":"#REF!"}},null,9,"17650-32000",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"17650-32000\")","v":{"$error":"#REF!"}},null,"Peon","9600-14550",300,0]
["D",0,null,"2017-01-01",2,null,null,null,null,null,null,null,8,"Driver",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Driver\")","v":{"$error":"#REF!"}},null,10,"19000-34500",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"19000-34500\")","v":{"$error":"#REF!"}},null,"Scavenger","9600-14550",300,0]
[null,null,null,"2017-02-01",1,null,null,null,null,null,null,null,9,"Daffedar",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Daffedar\")","v":{"$error":"#REF!"}},null,11,"20000-36300",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"20000-36300\")","v":{"$error":"#REF!"}},null,"SDA","11600-21000",0,0]
[null,null,null,"-",0,null,null,null,null,null,null,null,10,"Attender",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Attender\")","v":{"$error":"#REF!"}},null,12,"21600-40050",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"21600-40050\")","v":{"$error":"#REF!"}},null,"Sr.Driver","14550-26700",300,135]
[null,null,null,null,null,null,null,null,null,null,null,null,11,"Peon",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Peon\")","v":{"$error":"#REF!"}},null,13,"22800-43200",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"22800-43200\")","v":{"$error":"#REF!"}},null,"Sr.Typist","14550-26700",0,135]
[0,0,null,null,null,null,null,null,null,null,null,null,12,"FDA (Accounts)",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"FDA (A/cs)\")","v":{"$error":"#REF!"}},null,14,"24000-45300",null,null,"Stenographer","14550-26700",0,165]
[9600,200,null,null,null,null,null,null,null,null,null,null,13,"Scavenger",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Scavenger\")","v":{"$error":"#REF!"}},null,15,"26000-47700",null,null,"Suptd.","20000-36300",0,0]
[{"$f":"A17+B17","v":9800},200,null,null,null,null,null,null,null,null,null,null,14,"Suptd. (Accounts)",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"Suptd. (A/cs)\")","v":{"$error":"#REF!"}},null,16,"28100-50100",null,null,"Suptd. (A/cs)","20000-36300",0,0]
[10000,200,null,null,null,null,null,null,null,null,null,null,15,"Night Watchman",{"$f":"COUNTIF('MASTER FILE'!#REF!,\"N.Watchman\")","v":{"$error":"#REF!"}},null,17,"30400-51300",null,null,"Typist","11600-21000",0,135]
[10200,200,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O5:O19)","v":{"$error":"#REF!"}},null,18,"32800-52500"]
[10400,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"36300-53850"]
[10600,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"38100-55200"]
[10800,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"40050-56550",null,null,"Next Date of Birth  Age","Year-wise Commuta- tion Value"]
[11000,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"44250-60600",null,null,60,19.28]
[11200,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"48900-63600",null,null,17,19.2]
[11400,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"52500-73000",null,null,18,19.11]
[11600,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"56550-79800",null,null,19,19.010000000000002]
[11800,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"ALL INDIA SCALES (IAS, IPS & IFS)",null,null,20,18.91]
[12000,250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"OTHER SCALES IF ANY",null,null,21,18.809999999999999]
[12250,250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"LOCAL CANDIDATES [CONSOLIDATED PAY]",null,null,22,18.7]
[12500,250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S30)","v":{"$error":"#REF!"}},null,23,18.5]
[12750,250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,18.47]
[13000,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,18.34]
[13300,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,18.21]
[13600,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,18.07]
[13900,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,17.93]
[14200,350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,17.78]
[14550,350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,17.62]
[14900,350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,17.46]
[15250,350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,17.29]
[15600,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,17.11]
[16000,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,16.920000000000002]
[16400,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,16.72]
[16800,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,16.52]
[17200,450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,16.309999999999999]
[17650,450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,16.09]
[18100,450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,15.87]
[18550,450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,15.64]
[19000,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,15.4]
[{"$f":"A49+B49","v":19500},500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,15.5]
[20000,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,14.9]
[20500,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,14.64]
[21000,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,14.37]
[21600,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,14.1]
[22200,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,13.82]
[22800,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,13.54]
[23400,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,13.25]
[24000,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,12.95]
[24600,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,12.66]
[25300,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,12.35]
[26000,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,12.05]
[26700,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,11.73]
[27400,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,11.42]
[28100,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,11.1]
[28800,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,10.78]
[29600,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,10.46]
[30400,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,10.130000000000001]
[31200,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,9.81]
[32000,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,9.48]
[32800,800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,9.15]
[33600,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,8.82]
[34500,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,8.5]
[35400,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,8.17]
[36300,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,7.85]
[37200,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,7.53]
[38100,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,7.22]
[39000,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,6.91]
[40050,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,6.6]
[41100,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,6.3]
[42150,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,6.01]
[43200,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,5.72]
[{"$f":"A81+B81","v":44250},1050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,5.44]
[45300,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,5.17]
[46500,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,4.9000000000000004]
[47700,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,4.6500000000000004]
[48900,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,4.4000000000000004]
[50100,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,4.17]
[51300,1200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,3.94]
[52500,1350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,3.72]
[53850,1350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,3.52]
[55200,1350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,3.32]
[56550,1350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,3.13]
[57900,1350]
[59250,1350]
[60600,1500]
[62100,1500]
[63600,1500]
[65100,1500]
[66600,1500]
[68100,1500]
[69600,1700]
[71300,1700]
[73000,1700]
[74700,1700]
[76400,1700]
[78100,1700]
[79800,0]